package com.usian.skill.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.usian.skill.pojo.Goods;
import com.usian.skill.vo.GoodsVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface GoodsMapper extends BaseMapper<Goods> {
    @Select("SELECT * FROM `goods` g,skill_goods gs where g.id=gs.goodsId")
    List<GoodsVo> qclist();

    @Select("SELECT * FROM `goods` g,skill_goods gs where g.id=gs.goodsId  and g.id= #{id} ")
    GoodsVo huixian(Long  id);
}
